'Usage Dim instance As CalcAddressFunction Dim args() As Object Dim value As Object value = instance.Evaluate(args)
Parameters
- args
The args contains 2 - 5 items: row_num, column_num, [abs_num], [a1], [sheet_text].
Row_num is the row number to use in the cell reference.
Column_num is the column number to use in the cell reference.
[Abs_num] specifies the type of reference to return
[A1] is a logical value that specifies the A1 or R1C1 reference style. If a1 is true or omitted, ADDRESS returns an A1-style reference; if false, ADDRESS returns an R1C1-style reference.
[Sheet_text] is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.